IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_PageControlSelectOne]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[cms_sp_PageControlSelectOne]
GO
create procedure [dbo].[cms_sp_PageControlSelectOne]
@Id int
as
select 
	PageControlId as Id,
    PageId,
    TemplateRegionId,
	ModuleId,
    PageControlContentId,
    PageControlTypeKey,
    PageControlViewValue,
    PageControlModelValue,
    PageControlOrder,
    CreatedBy,
    DateCreated,
    LastUpdatedBy,
    DateLastUpdated
from [dbo].[PageControls]
where PageControlId = @Id


GO

